﻿<%@ Page Title="" Language="vb" AutoEventWireup="false" MasterPageFile="~/UserHome.Master" CodeBehind="MonitorPoints.aspx.vb" Inherits="LEAD.MonitorPoints" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
    <tr>
        <td>
            <form id="form1" runat="server">
            <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
                DataSourceID="SqlDataSource1">
                <Columns>
                    <asp:BoundField DataField="Points" HeaderText="Points" 
                        SortExpression="Points" />
                    <asp:BoundField DataField="Title_FK" HeaderText="Title_FK" 
                        SortExpression="Title_FK" />
                    <asp:BoundField DataField="ActionID_FK" HeaderText="ActionID_FK" 
                        SortExpression="ActionID_FK" />
                    <asp:BoundField DataField="TypeID_FK" HeaderText="TypeID_FK" 
                        SortExpression="TypeID_FK" />
                    <asp:BoundField DataField="UserID_FK" HeaderText="UserID_FK" 
                        SortExpression="UserID_FK" />
                    <asp:CommandField ShowEditButton="True" />
                    <asp:CommandField ShowDeleteButton="True" />
                </Columns>
            </asp:GridView>
            <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
                ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
                ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" 
                SelectCommand="SELECT [Points], [Title_FK], [ActionID_FK], [TypeID_FK], [UserID_FK] FROM [UserActivity]"
                UpdateCommand="UPDATE [UserActivity] SET Points=@Points where id=?"
                DeleteCommand="DELETE FROM [UserActivity] WHERE ID=?">
            </asp:SqlDataSource>
            </form>
        </td>
    </tr>
</asp:Content>
